Data: from 2021-09-06 to 2022-09-06. This analysis is to study how different annual members and casual riders used Cyclistic bikes.

1. Overall

The table below shows the summary of trip length statistics (in seconds).

DataType1 TripCount TripCountPercent Min_Length2 Q1_Length3 Median_Length4 Mean_Length5 Q3_Length6 Max_Length7
all 5,748,185 100% 0 362 640 1,180 1,154 2,442,301
casual 2,396,331 41.7% 0 472 830 1,754 1,524 2,442,301
member 3,351,854 58.3% 0 311 537 770 931 93,594
1 all - all trips, casual - trips made by casual riders, member - trips made by annual members
2 Min_Length: minimum trip length
3 Q1_Length: 25% of the trips have their length below Q1
4 Median_Length: 50% of the trips have their length below median
5 Mean_Length: the average trip length
6 Q3_Length: 75% of thr trips have their length below Q3
7 Max_Length: maximum trip length

2. Number of rides

By Day

By Month

3. Trip length

Trip Length by Month

Trip Length by User Type

Trip Length by Month and User Type

4. By day of week

Average number of rides per day by day of week

All

Nov - Feb

Mar - Oct

Trip Length by day of week

  • Mar-Oct vs. Nov-Feb

Trip Length by day of week by user type